Postgres Pro
Downloads
Home   >   mailing lists

Re: Table size does not include toast size - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Table size does not include toast size
Date
Msg-id 30E6478652370597ACE6BC32@[172.26.14.62]
Whole thread Raw
In response to Re: Table size does not include toast size  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-hackers
Tree view 

--On 22. Dezember 2009 11:46:32 +0100 Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:

> Did you mean :
>  pg_table_size() = base table + toast table
>  pg_indexes_size() = base indexes + toast indexes
> ?

Since you always have a toast index automatically it makes sense to include
them in pg_table_size().

--
Thanks
Bernd

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: alpha3 release schedule?
Next
From: Bernd Helmle
Date:
Subject: Re: Table size does not include toast size